-- @owner: wang_zhengyuan
-- @date: 2022/02/23
-- @testpoint:  select 语句中使用in,in条件中有子查询,目标列使用序列
--step1:select 语句中使用in,in条件中嵌套子查询,目标列使用序列;expect:查询成功
explain plan for select /*+parallel(4)*/ seq_hash_join_semi_001.nextval  from t_hash_join_semi_301 where id in (select id from t_hash_join_semi_wd);
select /*+parallel(4)*/ seq_hash_join_semi_001.nextval  from t_hash_join_semi_301 where id in (select id from t_hash_join_semi_wd);
select seq_hash_join_semi_001.nextval  from t_hash_join_semi_301 where id in (select id from t_hash_join_semi_wd);
